UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QE7vvuUp9IWh2kkcR5sR9NolTy6iK9RoM87ciEBfcos='
WHERE
key_id = 'b67b047f93881501e433370e9905a6faa4e1d03e442544f672a3f76eab94f9d7'
AND (
token = 'QE7vvuUp9IWh2kkcR5sR9NolTy6iK9RoM87ciEBfcos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)