UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z0KMaNwNd3rLGuHFokSgspDuMPDirbD61r+3WNcP9qI='
WHERE
key_id = '33d853c1d09436a5f47160a77b753eb49f7ff6a393f47e5ce8baa3a7d83baf1b'
AND (
token = 'z0KMaNwNd3rLGuHFokSgspDuMPDirbD61r+3WNcP9qI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)