UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Rojg4R2mUdJXDp7szsOPjXR2JLYh0eWaIEKTKfWXy8='
WHERE
key_id = '2a6280ddf208108171cfc49866caadc7ab6e1ccd926addb3fe919d65b2225bef'
AND (
token = '1Rojg4R2mUdJXDp7szsOPjXR2JLYh0eWaIEKTKfWXy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)