UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6u0y60VVB2ipDncLy7mYL0x7q294bEbKFZgDWIQh7X8='
WHERE
key_id = '7c1dc90372e445852425552490e13af9d944e87128c507eee9fe617b1e956a47'
AND (
token = '6u0y60VVB2ipDncLy7mYL0x7q294bEbKFZgDWIQh7X8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)