UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ib9jjEQgYmC2FdvF6Sc0y3lmac3+YPt9/K82LVRcejE='
WHERE
key_id = 'ca31380fc3c3f4f00ac837b257ed3aaadbb2ab95b4600408a3c0e03d691d3804'
AND (
token = 'ib9jjEQgYmC2FdvF6Sc0y3lmac3+YPt9/K82LVRcejE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)