UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qP7GQOtmph8cHzwU1dLot+lnoUPtMKlbwBjOmr1EWDQ='
WHERE
key_id = 'f2dbbf7057781da217bbad3748cb7e54635badcfa3f8b9fcc2c91f6640fef72a'
AND (
token = 'qP7GQOtmph8cHzwU1dLot+lnoUPtMKlbwBjOmr1EWDQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)