UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPF6scczu4SCqHQrQrn/EJQzSt8pncsOisa4jqGcqPk='
WHERE
key_id = 'a6dd39ebca15802e5c69b6208b3e2250c5825dfdaac190a68ee0e3cb7e0b1b04'
AND (
token = 'sPF6scczu4SCqHQrQrn/EJQzSt8pncsOisa4jqGcqPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)