UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7EoY8ZIpVOnZlW/xEPapOXAW3LhLlXo6ACyMMP3Deo='
WHERE
key_id = '04cfd67e1671b746d3043022c3169608943cda277a05555bc92eba80d3ab6269'
AND (
token = 'x7EoY8ZIpVOnZlW/xEPapOXAW3LhLlXo6ACyMMP3Deo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)