UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '52ihtoYMQsFBkLaG8dHLyyRU8SIk/BtsA29/vnQzLnE='
WHERE
key_id = 'edc692896c31ffb04d9d187e3d7130cd8a05317e5d0844f169f34d3d74867dde'
AND (
token = '52ihtoYMQsFBkLaG8dHLyyRU8SIk/BtsA29/vnQzLnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)