UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0hlvfj+cpodsQTNLJNeF1XgPlDv2Lo0iwDQUIDf6M5I='
WHERE
key_id = 'a8dffdf155690890e584bc4a52a7d8ee42655654fc58e7e191fe0ef55e4f9d01'
AND (
token = '0hlvfj+cpodsQTNLJNeF1XgPlDv2Lo0iwDQUIDf6M5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)