UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHfU5I0abQypCvOqetGA3gPzEtGO7slGNL+6Ln4ltbU='
WHERE
key_id = '3017475e9599137d11d26c0b8149e80692188fb2f1521c9b5a6b5b988e55a477'
AND (
token = 'nHfU5I0abQypCvOqetGA3gPzEtGO7slGNL+6Ln4ltbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)