UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9PgcFXEaGtuLY5ucP4aNMY9IFAVqxX/V6Kzy5V/89I='
WHERE
key_id = '3807b38f1e1c7ea03681a7080f2dbb437e6774601c7f73834c39493bee72b7ba'
AND (
token = 'A9PgcFXEaGtuLY5ucP4aNMY9IFAVqxX/V6Kzy5V/89I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)