UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KlvEHlX1n68llok2J0pHEt06SHtMnbU1ruhiarNdOgI='
WHERE
key_id = '78ca30349b742ceb66f22c91e5c2a8b1127a0b3894523fa67e0dc3ffe95d623c'
AND (
token = 'KlvEHlX1n68llok2J0pHEt06SHtMnbU1ruhiarNdOgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)