UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TlrlGXp2i4o4GZtlt4hsH/9KQ/dhwbjWrsKFYx11yk='
WHERE
key_id = 'e4598622b207f2d038ff71246744618463696f2b301fef8b74363997b1dcca25'
AND (
token = '9TlrlGXp2i4o4GZtlt4hsH/9KQ/dhwbjWrsKFYx11yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)