UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5xUv9RyqZfspc6yZ47XLIOyluMSdDhOleiOVNbqfPs='
WHERE
key_id = 'be54401f312ca1e868f99e1e04ae526a2bf207914f531d87c0887fe5f563d750'
AND (
token = 'G5xUv9RyqZfspc6yZ47XLIOyluMSdDhOleiOVNbqfPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)