UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/iL5jUQ/n8DJq7gX9GkD2h7S6uubXMeYVAzVzzVNjOI='
WHERE
key_id = 'bbeaedb434c995455f0a496bb00dd4924b062c47d1769bebcaec0749fc2d1a0d'
AND (
token = '/iL5jUQ/n8DJq7gX9GkD2h7S6uubXMeYVAzVzzVNjOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)