UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'II9J9e5Uw9efWhmDu+c5Cdt5ihunDo2/TU74iv1+rCA='
WHERE
key_id = 'bd9bf24447b5116ebd7f9a931c5caa78c19444c1647c5f024b576034f743f71b'
AND (
token = 'II9J9e5Uw9efWhmDu+c5Cdt5ihunDo2/TU74iv1+rCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)