UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZxMtjF8eN21odit3urO3RD/zfv9Mj4Lu8c8uxsw9cvs='
WHERE
key_id = '48aa4e58ce32d077ac41ff40ee8fffc764146979de88ac939c5335abc1ae0d69'
AND (
token = 'ZxMtjF8eN21odit3urO3RD/zfv9Mj4Lu8c8uxsw9cvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)