UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hlGQFnateMYpKYzXPHQ0jv4GomCCqkqidwTaGeUqNv8='
WHERE
key_id = '1f3b48079e1cc59b0d51663c72fdd0533a6881ee1f64be94368eeaef71b69ed7'
AND (
token = 'hlGQFnateMYpKYzXPHQ0jv4GomCCqkqidwTaGeUqNv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)