UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUBjgmAcEzR07ui5O3iBDZHLnRzxbDnltnFWrXSlF3E='
WHERE
key_id = '55c48d250ee105d6e910c9fba1301665ddbc5ff81761ce6b1121cf5a1edb501e'
AND (
token = 'ZUBjgmAcEzR07ui5O3iBDZHLnRzxbDnltnFWrXSlF3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)