UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vKidIdqPcM5+adxhUUbxxq+75wN++QNDlSiq8b3JZcI='
WHERE
key_id = '8dadfa3db5ab5bb33ffd4a9768f068eae7c65cdcbd267b93c84a94be10c9ef16'
AND (
token = 'vKidIdqPcM5+adxhUUbxxq+75wN++QNDlSiq8b3JZcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)