UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g0AlXxmR+ILqqsHi2ipAwSkTrJ7ruoBaQ5kLRTkcud8='
WHERE
key_id = '23d17cd45a7734bf0b285866274b27122d0595387b24b73a50779480928561ec'
AND (
token = 'g0AlXxmR+ILqqsHi2ipAwSkTrJ7ruoBaQ5kLRTkcud8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)