UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I7b7v/sn9EPBygnupS7YHlJ08NSZ20pw0r7ccm+HiCU='
WHERE
key_id = 'ba0f0148c612a299f2d9ce82ee089c6451d0a4d4ea0be0128e9a51121bb5b3ff'
AND (
token = 'I7b7v/sn9EPBygnupS7YHlJ08NSZ20pw0r7ccm+HiCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)