UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TRU12+tpNaQXLZCuyDVpXdgMFzOAr0IZJSqrcL9CBp8='
WHERE
key_id = '1792669518bc7bac23d325f79c5bec50e15f92db6f7c63ee51ef4d49ccee60ae'
AND (
token = 'TRU12+tpNaQXLZCuyDVpXdgMFzOAr0IZJSqrcL9CBp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)