UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MLi8offfLuiTGkjzAno+3bUTUQeIdf19bvbUxGS9gJ8='
WHERE
key_id = '8a8c178a8aebffd7f68d7c3851e1a9986196c27c5e981bc044477d6f5dd861b9'
AND (
token = 'MLi8offfLuiTGkjzAno+3bUTUQeIdf19bvbUxGS9gJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)