UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0VyBH5LHDsKKXb2ePTlDB9ORxRnDIaAsiWaj2wCIl70='
WHERE
key_id = '78763e98e4f2d9f56d2206c35d221917161fc6beb1350393dbb4dc5bedc775aa'
AND (
token = '0VyBH5LHDsKKXb2ePTlDB9ORxRnDIaAsiWaj2wCIl70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)