UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LH8dBgoJPerahfTDBcC2LHyRmu6BVpDOoHjx763L5Bk='
WHERE
key_id = '7ab78f25274203f84c0bebf2fe0cf0d3d155d191935a53821386dca5a0cd1a29'
AND (
token = 'LH8dBgoJPerahfTDBcC2LHyRmu6BVpDOoHjx763L5Bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)