UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iXchopsmSdHZLghxJNA8kS7IHgxQbLA3v1d/7aK78u4='
WHERE
key_id = '116329864895749aa6712e9adf75a5e9dfababc23e853db164c0e77b1b08cf0b'
AND (
token = 'iXchopsmSdHZLghxJNA8kS7IHgxQbLA3v1d/7aK78u4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)